#! /bin/sh
############################################################
#
# Backup/Recover Sechma Procedure from Oracle DataBase Package with SQLPLUS
#
###########################################################


echo -e "#---------------------- Import Sechma Process Start ------------------------#" 
echo  Start Execute Time: $(date +"%Y-%m-%d %T")  

DBUserName=system
DBPassword=manager
TNSName=siebeltest
DBFILE=/home/siebel/scripts/SIEBELPROD.dmp
OWNER=SIEBEL

cd /home/siebel/migrate/content/siebeldb/

/siebel/app/db/11.2.0/bin/imp  ${DBUserName}/${DBPassword}@${TNSName} file=${DBFILE} fromuser=${OWNER} touser=${OWNER} ignore=y


echo  End Execute Time: $(date +"%Y-%m-%d %T") 
echo -e "#---------------------- Import Sechma Process End ------------------------#"
